Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Undertake proactive maintenance of system
   • Prepare methodology to undertake platform database optimisation and administration effectively
   • Produce a cost-benefit analysis of database optimisation schedule to evaluate the effective return on investment (RoI) benefit to the organisation
   • Produce training instructions for new users on methodology to ensure effective database optimisation and administration
   • Interrogate and monitor system platforms to determine error logs, aging time on processes, database checks and system loadings
   • Notify appropriate personnel of problems and provide advice and guidance on likely solutions
   • Conduct system measurements from a user perspective on response times, and initiate investigations on problems where specifications are not being met
   • Assess availability of data storage space and initiate appropriate action where required
   • Develop procedures for system backup and restoration, review for efficiency of operation and amend where required
2. Provide application support to system users
   • Produce a set of procedures for formal meetings with users on a regular basis for effectiveness to discuss user issues and provide support
   • Set up a user support network to provide responsive system administration to users on an ongoing basis as critical issues arise
3. Create and delete user accounts
   • Create a hierarchical user profiling system to manage user accounts effectively according to enterprise policy
   • Establish and monitor security procedures relating to access according to policy
   • Assess grounds for deletion of user accounts and determine necessary action
4. Undertake special investigations
   • Evaluate requests for investigation to determine detail of action required
   • Prepare activity plan including timelines, specific goals, investigative team and resources required to conduct an investigation
   • Conduct investigation methodically according to plan and record findings
   • Analyse findings and prepare and forward reports, including recommendations to the requesting body

Performance Evidence

Evidence of ability to:

prepare a methodology for system maintenance

produce cost-benefit analysis and training for database optimisation and administration

review development of training instructions

conduct system measurements

develop support processes for system users

manage user accounts and security procedures

investigate potential system administration problems and make recommendations.

Note: If a specific volume or frequency is not stated, then evidence must be provided at least once.

---

Knowledge Evidence

To complete the unit requirements safely and effectively, the individual must:

summarise back-up systems

demonstrate a deep knowledge of computer systems

outline meeting procedures

outline the common methodology for system administration

summarise optimisation and administration of a database

provide a summary of telecommunications monitoring tools

explain the process for investigation requests and actions

outline user account security and profiling system.

---